package com.hand.llq25404.mapper;

import com.hand.llq25404.entity.SsmItem;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface IItemMapper {

    List<SsmItem> pagingQuery(@Param("start") int start, @Param("pageSize") int pageSize);

    List<SsmItem> getSsmItems();

    void addItem(SsmItem ssmItem);

    String maxItem();

    void delItem(@Param("itemId")String itemId);

    SsmItem queryId(Long itemId);

    void update(@Param("s")SsmItem ssmItem,@Param("itemId")long item_id);

    List<SsmItem> getCount(SsmItem ssmItem);

    List<SsmItem> fuzzyQuery(@Param("start") int start, @Param("pageSize") int pageSize,@Param("itemCode") String itemCode,@Param("itemDescription") String itemDescription,@Param("itemUom") String itemUom,
                             @Param("startActiveDate") String startActiveDate,@Param("endActiveDate") String endActiveDate,@Param("enabledFlag") String enabledFlag);

    List<SsmItem> getCount(@Param("itemCode") String itemCode,@Param("itemDescription") String itemDescription,@Param("itemUom") String itemUom,
                           @Param("startActiveDate") String startActiveDate,@Param("endActiveDate") String endActiveDate,@Param("enabledFlag") String enabledFlag);

}
